Unit of Competency Mapping – Information for Teachers/Assessors – Information for Learners
ICAB4136B Mapping and Delivery Guide
Use structured query language to create database structures and manipulate data
Version 1.0
Issue Date: May 2024
Qualification | - |
Unit of Competency | ICAB4136B - Use structured query language to create database structures and manipulate data |
---|---|---|---|
Description | This unit defines the competency required to use a structured query language (SQL) to define, create and manipulate database structures and associated data in a relational database.The following units are linked and form an appropriate cluster:ICAB4060B Identify physical database requirementsICAB4061B Monitor physical database implementationNo licensing, legislative, regulatory or certification requirements apply to this unit at the time of publication. | ||
Employability Skills | This unit contains employability skills. | ||
Learning Outcomes and Application | |||
Duration and Setting | X weeks, nominally xx hours, delivered in a classroom/online/blended learning setting. |
||
Prerequisites/co-requisites | ICAB4225B Automate processes | ||
Competency Field |
Development and validation strategy and guide for assessors and learners | Student Learning Resources | Handouts Activities |
Slides PPT |
Assessment 1 | Assessment 2 | Assessment 3 | Assessment 4 | |
---|---|---|---|---|---|---|---|---|
Elements of Competency | Performance Criteria | |||||||
Element: Write a simple SQL statement to retrieve and sort data |
| |||||||
Element: Write an SQL statement that selectively retrieves data |
| |||||||
Element: Write SQL statements that use functions |
| |||||||
Element: Write SQL statements that use aggregation and filtering |
| |||||||
Element: Write SQL statements that retrieve data from multiple tables |
| |||||||
Element: Write and execute SQL sub-queries |
| |||||||
Element: Create and manipulate tables |
| |||||||
Element: Create and use views |
| |||||||
Element: Create and use stored procedures |
|